let server = require('express')();
let mysql = require('mysql');
const port = 81;

server.all("*", function(req, res, next) {
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin", "*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers", "content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods", "DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200); //让options尝试请求快速结束
    else
        next();
})



// 规划链接
let sql = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '123456',
    database: 'student',
    port: 3307
});

// 尝试链接
sql.connect();

// 返回案例所有信息
server.get("/caseList", function(request, response) {
    sql.query('SELECT * FROM case1', function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
    })
})

//给后端传数据
server.get("/casedetail", function(request, response) {
    let id = request.query.id;
    sql.query(`SELECT * FROM case2 WHERE id=${id}`, function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
        console.log(`从案例列表接收到id=${id}的数据`)
    })
})

server.get("/solutiondetail", function(request, response) {
    let id = request.query.id;
    sql.query(`SELECT * FROM solution2 WHERE id=${id}`, function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
        console.log(`从解决列表接收到id=${id}的数据`)
    })
})

// 返回解决方案所有信息
server.get("/List", function(request, response) {
    sql.query('SELECT * FROM solution1', function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
    })
})

// 返回解决方案详情所有信息
server.get("/List2", function(request, response) {
    sql.query('SELECT * FROM solution2 ', function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
    })
})


// 返回案例详情所有信息
server.get("/List3", function(request, response) {
    sql.query('SELECT * FROM case2', function(error, data) {
        if (error) {
            console.log(error)
            response.end('error')
            return;
        }
        response.end(JSON.stringify(data));
        console.log(id)
    })
})



server.listen(port)
console.log("server is running at" + port)